An Efficient Secure System for Fetching Data From the Outsourced Encrypted Databases

Recently, database users have begun to use cloud services outsource their databases. The reason for this is the high computation speed and huge storage capacity that owners provide at low prices. However, despite attractiveness of computing environment users, privacy issues remain a cause concern since data access out control. Encryption only way assuaging users' fears surrounding privacy, but executing Structured Query Language (SQL) queries over encrypted challenging task, especially if are by randomized encryption algorithm. Many researchers addressed encrypting using deterministic, onion layer, or homomorphic encryption. Nevertheless, even with these systems, can still be subjected attack. In research, we first propose an indexing scheme encode original table's tuples into bit vectors (BVs) prior resulting index then used narrow range retrieved records from small set candidates user's query. Based on scheme, design system execute SQL data. single algorithm, namely Advanced Standard-Cipher-Block Chaining (AES-CBC). proposed store values side, extend support most relational algebra operators, such as select, join, etc. Implementation evaluation reveals it practical efficient reducing both space overhead when compared state-of-the-art systems like CryptDB.